package com.eascs.workflow.timeEffective.dao.impl;

import java.util.Date;
import java.util.List;
import org.springframework.stereotype.Repository;
import com.eascs.workflow.common.dao.BaseDao;
import com.eascs.workflow.common.entity.timeEffective.WorkdayEntity;
import com.eascs.workflow.timeEffective.dao.WorkdayDao;

@Repository
public class WorkdayDaoImpl extends BaseDao implements WorkdayDao{

	@Override
	public List<WorkdayEntity> queryWorkDays(Date start, Date end) {
		String sql="SELECT * FROM wf_workday WHERE workday BETWEEN DATE_FORMAT(?,'%Y-%m-%d')  AND DATE_FORMAT(?,'%Y-%m-%d') ORDER BY workday ASC";
		return super.findEntitys(sql, WorkdayEntity.class, new Object[]{start,end});
	}

}
